<?
	include('chksession.php');
	include('conn.php');
	session_start();
    $data = file_get_contents("php://input");
    $objData = json_decode($data);
	
	   $msg='';
       $Can_Date= $objData->Can_Date;
       $Pax_Name= $objData->Pax_Name;
	   $No_of_Pax= $objData->No_of_Pax;
	   $Airline= $objData->Airline;
	   $Sector= $objData->Sector;
	   $Net_Rate= $objData->Net_Rate;
	   $Refund_Amt= $objData->Refund_Amt;
	   $Refund_Date= $objData->Refund_Date;
	   $Agent_Rate= $objData->Agent_Rate;
	   $Agent_Ref_Amt = $objData->Agent_Ref_Amt;
	   $Reference_Date = $objData->Reference_Date;
	   $Comment = $objData->Comment;
	   $entrydt = $objData->entrydt;
	   $cantrndetid = $objData->cantrndetid;
	   $enteredby=$_SESSION['username'];
	
	$sqlc="insert into canceltrandetails(Can_Date,Pax_Name,No_of_Pax,Airline,Sector,Net_Rate,Refund_Amt,Refund_Date,Agent_Rate,Agent_Ref_Amt,Reference_Date, Comment,enteredby,entrydt)
		values('".$Can_Date."','".$Pax_Name."','".$No_of_Pax."','".$Airline."','".$Sector."','".$Net_Rate."','".$Refund_Amt."','".$Refund_Date."','".$Agent_Ref_Amt."','".$Reference_Date."','".$Comment."','".$enteredby."',sysdate())";
		$resc=mysql_query($sqlc);
		if($res)
			$msg='Record saved successfully';			
		echo $msg;
?>